Conditional Format on Multiple Rows if Value of one cell on each row is less than a %

[cpiname]

Hi,

Basically, I have a spread sheet, on which I have a few columns.

Column D has amount
Column E has potential amount
Column F has the percentage(so amount is 50, potential is 100, percentage is 50.00%)

Its the same for every row.

I want the row to highlight red..if column F is less than 20%.

But I want to do that on each row, without having to enter the conditional format formula every time(which so far is the only ive been able to figure it out).

Can anyone help with this?

[teylyn]

Select the whole table, then enter the conditional format with "Formula Is"
(assuming that your data starts in row 2 and row1 has labels, select A2 to last column/last row)

=$F2<0.2

Select a fill/font format and hit OK. The format will apply to all selected cells, comparing in each row if column F of the respective row is less than 20%

cheers

[cpiname]

Great, thanks

I'd been putting =$F$2<0.2 and it wasnt having it.

removing the $ sign has made it work.

Thanks