need to format a cell based on 2 others

August 23, 2011 at 05:57:42
Specs: Windows XP
i have 3 columns and 25 rows of data ...and i want to color format column A cells based on a number value, say any cell greater than 25 in column B and a specific TEXT value in column C

See More: need to format a cell based on 2 others

Report •

August 23, 2011 at 13:57:00
Read up on Conditional Formatting in the Excel Help files.

You can set up Rules (or Conditions, depending on what version of Excel you are running) such as:

=AND(B1>25, C1="MyText")

Whenever the Rule evaluates to TRUE the Conditional Formatting will be applied.

Click Here Before Posting Data or VBA Code ---> How To Post Data or Code.

Report •

August 24, 2011 at 05:19:02
Thanks! that was perfect..dont know why i couldnt get that to work on my own! NOW my next problem is how to get that to span multiple rows....i need to run that rule against each row....

Report •

August 24, 2011 at 05:31:30
Actually that was not my next question sorry...but your answer t9o my first problem was spot on..again my REAL problem is my TEXT column, Column C, i need to validate the rule to if a specific word is in the cell...not just one word other words i am look to see if CARS (for instance) is in that cell in a string of words ....anywhere...

value of Column C Row 1 = green cars
value of Column C Row 2 = green trucks

i need the rule to change "Column A row 1 or 2" RED based on if CARS shows Column C

Report •

Related Solutions

Ask Question