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 4478 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 response

rizvisa1 Posts 4478 Registration date Thursday January 28, 2010 Status Contributor Last seen May 5, 2022 766
Oct 7, 2015 at 12:04 PM
what version of excel and are all users using same version of excel.
We are using Excel 2010
rizvisa1 Posts 4478 Registration date Thursday January 28, 2010 Status Contributor Last seen May 5, 2022 766
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