Format cell based on two values

Orangeanorak

Board Regular
Joined
Nov 22, 2002
Messages
248
Hi grateful if you can provide a formula for the following to format a cell based on two different values

=IF(G4 equals 6 or zero,"enter words","")
 

Some videos you may like

Excel Facts

How to find 2nd largest value in a column?
MAX finds the largest value. =LARGE(A:A,2) will find the second largest. =SMALL(A:A,3) will find the third smallest

Nine Zero

Well-known Member
Joined
Mar 10, 2016
Messages
622
sorry just now seeing this ...

yeah no problem just add it in the or statement

=IF(AND(Q2>1,OR(G4=6,G4=0)),"enter words,"")
 

Watch MrExcel Video

Forum statistics

Threads
1,109,251
Messages
5,527,636
Members
409,778
Latest member
MagalieD

This Week's Hot Topics

Top