View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
ShaneDevenshire ShaneDevenshire is offline
external usenet poster
 
Posts: 2,344
Default Conditional Formatting

Hi,

Yes, when you go into Conditional Formatting, choose Formula is from the
first drop down and in the second write a formula, for example

=A1200

while on B1.
--
Thanks,
Shane Devenshire


"Jamie" wrote:

Can I add conditional formatting on one cell (A1) BASED on the criteria from
another cell (B1)?
Here's what I want to do. IF B1 is populated at all, then I would like A1 to
have a specific coditional formatting. Is this possible?