Format Cells based on 1 or 2 Cell(s)

C

ChrisBat

Hi,

I have a spreadsheet with a combo box in the first two
columns (selections are Create, Delete, and Modify). I
would like to set the conditional formatting to change
Cells A:AE green for Create, Red for Delete and Yellow for
Modify for the particular row.
I have tried the Conditional Formatting option, using the
Formula Is option, with the formula ="Create" and =If
($A:$AE="Create) and neither works. I have been building
a database all day and can't see straight, which could be
part of the problem.
Any one out there able to help a guy stuck in T.O.?
Thanks Muchly,
Chris
 
C

Charlie

Chris,

Instead of using 'Formula is', use 'Cell Value is', 'equal
to', and enter ="Create" and choose a format and so on.

Charlie O'Neill
 
Top