View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
carlo carlo is offline
external usenet poster
 
Posts: 367
Default Changing Cell Color

Select A1 goto Format -- Conditional Formatting, there you enter:

Formula is =B10

and then you select the properties you want for cell A1

hth

Carlo

On Dec 5, 3:26 pm, Spz wrote:
How do you change the color of a cell?

If the formula calculates a value greater than $0 in B1, how can I
change A1 to blue?

A1 B1
$4.80 $3.60

When B1 is greater than 0, I want A1 to turn blue.