Thread
:
Conditional format
View Single Post
#
2
Posted to microsoft.public.excel.worksheet.functions
Sandy Mann
external usenet poster
Posts: 2,345
Conditional format
Both your formulas work for me as cell formulas so I assume that you are
talking about Conditional Formatting.
Select: Format Conditional Foprmatting Cell Value is: select the arrow
head and select "greater than" and enter 0 and the select the formatting
that you want.
--
HTH
Sandy
In Perth, the ancient capital of Scotland
and the crowning place of kings
Replace @mailinator.com with @tiscali.co.uk
"Emerogork via OfficeKB.com" <u36894@uwe wrote in message
news:77a2a7c192549@uwe...
I believe that I want to use something like this but it doesn't seem to
work:
=IF(CC70,1,0)
I have also tried: =IF(CC7<"",1,0)
If the value in CC7 is greater than 0 then place the number 1 in the cell
otherwise plae a 0 in the cell.
If the value in CC7 has any value then place the number 1 in the cell
otherwise place a 0 in the cell.
CC7 usually contains a time value
Should this work?
I have tested various entries in CC7 but get no results.
I don't get any errors, just blank stares from the computer (-:
P.S. When working in the field when entering a conditional setting, I am
inclined to use the arrows to navigate the equation. Of course, the
system
starts filling the equation with cell addresses.
Is ther a way to use the arrow keys in this situation?
--
Message posted via
http://www.officekb.com
Reply With Quote
Sandy Mann
View Public Profile
Find all posts by Sandy Mann