Copying Conditional Formatting Colors from a Cell

**Ridgebacks** · 10-06-2007, 04:55 PM

I am able to get a cell in a column called Status to change fill colors based on the text that is entered into the cell. What I want to do now is have the rest of the row change fill color to match that conditional color in the Status column cell. Is there a way to do this?

**VBA Noob** · 10-06-2007, 05:10 PM

Hi,

Try to avoid selecting the whole row.

Say your data in Col A to Col H.

Select say A1 to H100. Then enter this in CF under formula

=$A1="Status"

Assumes col A is the col that triggers CF and the word "Status" is the trigger

http://www.contextures.com/xlCondFormat01.html

VBA Noob