VBA macro to color a range of cells based on value of other cell

Closed
Ashok - Oct 6, 2015 at 04:47 PM
rizvisa1 Posts 4479 Registration date Thursday January 28, 2010 Status Contributor Last seen May 5, 2022 - Oct 7, 2015 at 09:25 PM
Hello,

I' am using a shared file and hence could not use conditional formatting.

I want range C2:F2 should turn Blue is the value in cell G2 is "Done"
If G2 blank or other wise it should remain normal.

I want this to happen on every range from C2:F50

1 reply

rizvisa1 Posts 4479 Registration date Thursday January 28, 2010 Status Contributor Last seen May 5, 2022 768
Oct 7, 2015 at 12:04 PM
what version of excel and are all users using same version of excel.
0
We are using Excel 2010
0
rizvisa1 Posts 4479 Registration date Thursday January 28, 2010 Status Contributor Last seen May 5, 2022 768
Oct 7, 2015 at 09:25 PM
In that case my understanding is that you can use conditional format. Only change in conditional format cannot be done unless you disable sharing. But existing formatting formula should still work
0