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

Vba change cell color based on value
Notepad++ change background color - Guide
Based on the values in cells b77:b81, what function can automatically return the value in cell c77? ✓ - Excel Forum
Vba case like - Guide
Change computer name cmd - Guide
Vba color index - Guide

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.

ashokk
Oct 7, 2015 at 08:40 PM

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

Similar discussions

VBA: Color cells in table based on multiple condition

Excel VBA - Change cell color based on value

Condition formatting on changing cell color based on another cel

How to use conditional format based on text?

Change colour of range of cells based upon text from a drop down menu in another

if sum>= 60, color cells red

Similar discussions

Subscribe To Our Newsletter!