T
Tom Freeman
I am attempting to conditional format an entore row based on one columns
results. What is the best way to do this? Thanks.
results. What is the best way to do this? Thanks.
You are using an out of date browser. It may not display this or other websites correctly.
You should upgrade or use an alternative browser.
You should upgrade or use an alternative browser.
M
Mike H
tom
Select then row (I used row 1) then
Format|Conditional format - formula is
enter the formula
=$A$1=99
pick a colour
OK
Enter 99 in a1 and the entire row is coloured.
Mike
Select then row (I used row 1) then
Format|Conditional format - formula is
enter the formula
=$A$1=99
pick a colour
OK
Enter 99 in a1 and the entire row is coloured.
Mike
S
Sheeloo
Use
=$A1=99
if you want to paint the formula down to other rows. You may also select
more than one row, starting at row 1 and then enter the above formula
=$A1=99
if you want to paint the formula down to other rows. You may also select
more than one row, starting at row 1 and then enter the above formula
S
Sam H
Mike H said:tom
Select then row (I used row 1) then
Format|Conditional format - formula is
enter the formula
=$A$1=99
pick a colour
OK
Enter 99 in a1 and the entire row is coloured.
Mike
S
Sam H
Mike, in your formula, what would I use in place of "99" if the space is
originally blank and I intend to enter dates there. I would like to highlight
the row when the date is entered. No specific date is expected to be entered
as it would be based on when the action occurs.
Thanks,
originally blank and I intend to enter dates there. I would like to highlight
the row when the date is entered. No specific date is expected to be entered
as it would be based on when the action occurs.
Thanks,
S
Sheeloo
Try
=$A1>1
If you are entering dates in the current century ( 1/1/2000 or later)
then you can use
=$A1>36525
=$A1>1
If you are entering dates in the current century ( 1/1/2000 or later)
then you can use
=$A1>36525