shading a rowwhen a time is entered but no shading when 0 is e
When you change Condition 1 dropdown to Formula Is, there will be an empty
text box to the right. Add it there.
--
HTH
RP
(remove nothere from the email address if mailing direct)
"fomula problems" wrote in
message ...
Bob cheers have tried to do as you say but when i get the conditioning
formatting boxes come up i changed the condition one to IS okay but could
not
fill the other boxes where do i enter the formula, sorry to be a pain.
Alan
"Bob Phillips" wrote:
Select all the rows, starting at 1
Menu FormatConditional Formatting
Change Condition 1 to Formula Is
Add a formula of =AND($G1<"",$G1<0)
Click the Format button
Select the Pattern Tab
Select an appropriate highlighting colour
OK
OK
--
HTH
RP
(remove nothere from the email address if mailing direct)
"fomula problems" wrote in
message ...
I know that i need to use conditional formatting, but have never done
it
before tryied to use it it but did not understand how to use it and
what
to
put in the boxes.
Alan
"Barb Reinhardt" wrote:
You need to use conditional formatting to do what you want.
"fomula problems" wrote
in
message ...
Sloth i know that you replied with a formula, but still cannot get
it
to
work.below is the sort of worksheet i am using, and have discribed
below
what
i want it to do.
also can you explain how to enter the formula and where thank you.
A B C D E G
1 63 59 78 89 58 12:40
2 22 54 36 74 25 11:10
3 19 36 27 46 58 12:25
4 46 98 68 96 56 0
When i enter a time is column G i would like the wholeof that row
to
highlighted up to and including G, if i enter 0 because a time has
not
been
established i do not want the row to be highlighted, but then if i
do
establish a time late i can enter the time and the row will be
highlighted,if
the formula you gave me will do that, could you also let me know
how
to
enter
it on the worksheet, new to this sort of thing.
Alan
|