You're welcome.
While still on the subject...excel conditional formatting offers 4
conditions already. 1, 2, 3 and the 'else' part gives a choice for 4th
formatting (default).
Also for more than 03 conditions, below link offers some ideas.
http://www.ozgrid.com/Excel/font-formats.htm
Thanks
Hi All,
Is there any possibility to do conditional formatting on based upon
more than two conditions in a specific area in excel 2007.
for Example:- if($h2=done) then 1st formatting. otherwise
if(and($h2,$h2), then 2nd formatting. otherwise no format apply.
--
FORUM RULES (986+ members
This worked for me -
=$H$2=done 1st formatting
=IF(AND($H$2ABC),($H$2XYZ))=FALSE
OR
=IF(AND($H$2=ABC),($H$2=XYZ))=TRUE 2nd formatting
If there is done in H2 it will become blue. If there is ABC or XYZ in
H2 it will become red. Else no format would be applied.
Please elaborate if you need