Not sure I am getting this.... I seem to have to do it individually to each
cell. I have 2 conditions in each cell. If between 69 and 1 then red bold
number and if equal to "0" then red fill in. I tried to do format painter and
it's not copying it. It changes the format on the "0" portion fo the
condition to """"---0""""". How do I copy the entire conditioning for that
column? Thank you......

"Pete_UK" wrote:

If you have already applied it to one cell, then use the Format
Painter icon to copy that format to the other cells.

Hope this helps.

Pete

On May 19, 4:01 pm, shamor wrote:
Thank you for the response but I want to do it for the whole column E3 to
E200 if any of the values in that column fall under 70 its bold and red and
if value is 0 then cell is filled red.



"Tim879" wrote:
Go to format - Conditional Formatting .

if you're trying to format the current cell if it's under 70....
enter Cell Value is < 70

If you're trying for format the current cell if another cell is less
than 70....
enter Formula is =A1<70 (REPLACE A1 WITH WHAT EVER CELL YOU WANT TO
REVIEW)

then just click on the Format button and set whatever format you want

On May 19, 8:48 am, shamor wrote:
How do I red and bold text on a # in a column if it falls under 70?- Hide quoted text -

- Show quoted text -