Thread: Change cell background based on multiple cells
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Peo Sjoblom Peo Sjoblom is offline
external usenet poster
  
Posts: 3,268
Default Change cell background based on multiple cells
Formula is

=AND($A$1="Hourly",$C$3<10)


2nd condition


=AND($A$1="Salary",$C$314)


works for me


--
Regards,

Peo Sjoblom

wrote in message
ups.com...
This is what I'm trying, unsuccessfully, to do:

If the value of A1 is "Hourly" AND the value of C3 is <10, change the
background to yellow
If the value of A1 is "Salary" AND the value of C3 is 14, change the
background to green

I have been unable to do this using conditional formatting.
Can someone help with VB?

Thanks!!



Reply With QuoteReply With Quote