Khimasia

[Closed]
Report
-
Posts
4476
Registration date
Thursday January 28, 2010
Status
Contributor
Last seen
August 2, 2020
-
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 reply

Posts
4476
Registration date
Thursday January 28, 2010
Status
Contributor
Last seen
August 2, 2020
768
as per above what ????