Previous Topic Next Topic

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
Related:

1 response

Answer 1 / 1
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.
0
ashokk
Oct 7, 2015 at 08:40 PM
We are using Excel 2010
0
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
0

Similar discussions

VBA: Color cells in table based on multiple condition
abdelfatah_0230 -
abdelfatah_0230 -

2 responses
Excel VBA - Change cell color based on value
Tandar -
ac3mark -

14 responses
Condition formatting on changing cell color based on another cel
Saitoh7 -
Mazzaropi -

1 response
How to use conditional format based on text?
Leanne99 -
Mooseman -

26 responses
Change colour of range of cells based upon text from a drop down menu in another
Jim1409 -
TrowaD -

1 response
if sum>= 60, color cells red
mindy -
mindy -

4 responses