Previous Topic Next Topic

Conditional Formating

Closed
Lamees - Mar 1, 2012 at 10:44 AM
venkat1926 Posts 1863 Registration date Sunday June 14, 2009 Status Contributor Last seen August 7, 2021 - Mar 1, 2012 at 10:25 PM
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 response

Answer 1 / 1
venkat1926 Posts 1863 Registration date Sunday June 14, 2009 Status Contributor Last seen August 7, 2021 811
Mar 1, 2012 at 10:25 PM
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
0

Similar discussions

Highlight cell if another cell contains specific text
Abbi -
vcoolio -

1 response
How to use conditional format based on text?
Leanne99 -
Mooseman -

26 responses
Formula for conditional format to color cells
kipp2019 -
TrowaD -

14 responses
Highlight cell if another cell contains any text
LvH -
LvH -

4 responses
Conditional formating - apply on more cells
Biljana -
Raj -

32 responses