Previous Topic Next Topic

Conditional Formating

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

Réponse 1 / 1
venkat1926 Posts 1863 Registration date Sunday 14 June 2009 Status Contributor Last seen 7 August 2021 811
1 Mar 2012 à 22:25
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

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
Conditional Format Cells Based on Another Cell and Own Cell
Elaine -
x -

1 response
Conditional formatting based text in another cell
y88y -
y88y -

2 responses
Conditional Formatting - highlight overdue dates
TanyaRT -
TanyaRT -

2 responses