Noob conditional formatting - applying to entire blank sheet before entering data

[PipBoy808]

I've been digging around VBA for the past couple of weeks so much that I've forgotten some basic conditional formatting stuff!

In the attached workbook I've applied some conditional formatting to Row 2, which you can see under 'Manage Rules'. How would I apply the formula to all rows up to say, 200, so that:

"Every time there's a day header in column A, that entire row is filled black and the header font is filled white."

It's pretty frustrating when you spend the day writing a complex import macro and then can't remember how to do things like this ...

Thanks!

 

[Xiq]

Hi PipBoy,

You can use the following formula:

=LEN(A$1)>0

Simply make two rules: one for the rows 2:200 and one for the header row

 

[Xiq]

Here is the file with the applied rules

 

[PipBoy808]

That's close, but not quite what I need. Looking back, I didn't explain it very well. My bad!

The location of the days is dynamic as the data is imported via a macro, so I effectively need to have the rule cover every row but only apply the formatting to rows with a header in them.

Check out the attached workbook to see what I mean.

 

[Luke M]

You were pretty close. I believe the CF rule should be:
=RIGHT($A2,3)="day"
Applied to range A2:M100 (or some arbitrary range).