still learning
Well-known Member
- Joined
- Jan 15, 2010
- Messages
- 784
- Office Version
- 365
- Platform
- Windows
Hi,
I'm having trouble getting Conditional Format to copy down a column using the painter icon
I want a cell to be formatted to bold if a different cell doesn't have an "r" in it.
I click on G1 and bring up conditional format and put in this formula:
then i format it to bold
the problem is when I try to copy it down
It keeps referring to F1, not F2, then F3, then F4, etc.
I don't want to have to type it in each G cell changing the reference cell.
I want the reference cell to change (F) as I enter date in (G)
mike
I'm having trouble getting Conditional Format to copy down a column using the painter icon
I want a cell to be formatted to bold if a different cell doesn't have an "r" in it.
I click on G1 and bring up conditional format and put in this formula:
Code:
=F1<>"r"
the problem is when I try to copy it down
It keeps referring to F1, not F2, then F3, then F4, etc.
I don't want to have to type it in each G cell changing the reference cell.
I want the reference cell to change (F) as I enter date in (G)
mike