Unfortunately, I does not work totally. The designated rows change (the rows
which the formats effect), however the formula stays the same for every row.
That is not what we want.
I need to have every row effect the rows designated, so if an x is in A4,
only cells b4
4 are effected. And if R7 = True, then only cells b7
7 are
effected. Etc.
Each row stands alone as a conditional format, but I can't find a way to
make one row correct for our conditional formate and then copy that to each
of the 1000 lines I need without having to edit every row individually. I
don't have that much time.
Thanks, Pete -US.
"Pete_UK" wrote:
Just go into Conditional Formatting again for that cell and check that
Excel has not added $ in front of the 4 in the formulae - if it has,
then remove them. Then you can repeat that CF for other cells by using
the Format Painter - if you double-click on the icon you can then
apply the format to many other cells by means of a single-click, and
then press Esc when you have finished.
Hope this helps.
Pete
On Sep 22, 8:30 pm, Pete wrote:
I need to set-up three formali in each row of a 1000 row spreadsheet. The
three forumli a
=A4="x" then B4 : P4 strickthrough, green font
=B4Today() B4:P4 Font Red
=R4=True B4:P4 Font Purple Italic.
I enter that in Row 4 , now I need to repeat this for every row, but every
attempt fails to change the row identifier- thus every row ends up refering
to row 4 only. Hope do I copy this instead hand writing each row- 1000 rows?