Conditional Questions

[Michael]

I have searched through these forums trying to see if what
I want to do is possible without using macro, have not had
much luck...

I am trying to make a document run more efficiently by
using formulas.....

what I need to do is make it so that once today's date is
later than a date in a certain cell every cell that is
either an N or and X in that row changes format to a black
background and white font.

Is there a way to write a single conditional formula to do
all of that for a single row?

if you could help that would be great, thanks!!!!!!!!!!!!!!
michael

 

[CarlosAntenna]

Use format / conditional formatting.

 

[Cutter]

If the cell containing the date is in A1 and the cells you want to
format are in same row:
-select the cells you want to format
-go to Format - Conditional Formatting
-choose Formula Is from the drop down list
-in the formula area type this
=AND($A$1<TODAY(),OR(B1="N",B1="X"))
-click Format
-on Font tab choose whie for colour
-on Pattern tab choose black
-click OK
-click OK