Khimasia

Closed
Sheenal - 9 Jul 2010 à 10:44
rizvisa1 Posts 4478 Registration date Thursday 28 January 2010 Status Contributor Last seen 5 May 2022 - 9 Jul 2010 à 16:46
Hello,

As per above im doing multiple cells conditional formatting but from another worksheet

=IF(INDIRECT("'Blue Input'!bd13")>0,TRUE,FALSE)

Using the formula above im applying the conditional formatting to each cell individually

i.e. blue input BD13 related to BD13 in this worksheet etc.

How do I do the same for multiple cells in one go?

I tried doing it the same way as stated above but it doesnt seem to work when your pulling data from another worksheet.

1 response

rizvisa1 Posts 4478 Registration date Thursday 28 January 2010 Status Contributor Last seen 5 May 2022 766
9 Jul 2010 à 16:46
as per above what ????