Hi
I have this formula (=NOT(ISBLANK($T$6)), that I have used in conditional formatting that I need to copy down cell. Can anyone advise.
Hi
I have this formula (=NOT(ISBLANK($T$6)), that I have used in conditional formatting that I need to copy down cell. Can anyone advise.
Remove the conditional formatting you already have.
Select the range you want to highlight starting at T6 presumably?
Conditional Formatting
New Rule
Use a formula to determine...
=NOT(ISBLANK(T6))
Format as required
Regards
Special-K
Ensure you describe your problem clearly, I have little time available to solve these problems and do not appreciate numerous changes to them.
Remove $ before 6. If copy down you can't block rows.
Happy with my answer * Add Reputation.
If You are happy with solution, please use Thread tools and mark thread as SOLVED.
they both worked. Thank you both
Happy to help.
If You are happy with solution, please use Thread tools and mark thread as SOLVED.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks