Conditional Formating

[Closed]
Report
-
Posts
1864
Registration date
Sunday June 14, 2009
Status
Contributor
Last seen
August 7, 2021
-
Hello,

I am trying to conditional fomat a cell based on the results of two cells. If the fist cell has the word standard, and the other cell is >3 then highlight the number that is >3 with yellow?


Thank you,

1 reply

Posts
1864
Registration date
Sunday June 14, 2009
Status
Contributor
Last seen
August 7, 2021
803
suppose first cell is A1 having the entry "standard"
and the second cell is B1 having entry either more than 3 or less than equal to 3

select B1

conditional formatting window
first
the cell value
greater than
3
dont do the formt now
click "add"
in the bottom window
the formula is
=OFFSET(B1,0,-1,1,1)="standard"
click the format
pattern
and choose color
click ok twice