How to auto shade A1 red if B1 is shaded red?
- Thread starter RadMan
- Start date
Radman
You can't directly get the color of a cell without using a UDF
But you can use conditional formatting based on some other factor like a value in B1 or another cell is at a certain value, which can be used to trigger the CF
Can you explain further what is happening or post a file for us to review what is going on?
You can't directly get the color of a cell without using a UDF
But you can use conditional formatting based on some other factor like a value in B1 or another cell is at a certain value, which can be used to trigger the CF
Can you explain further what is happening or post a file for us to review what is going on?