Not using Conditional Formatting - change cell colors

Page 1 of 1

1 Replies - 672 Views - Last Post: 13 January 2012 - 05:15 PM Rate Topic: -----

#1 D_MeNtEd  Icon User is offline

  • New D.I.C Head

Reputation: 2
  • View blog
  • Posts: 32
  • Joined: 27-August 10

Not using Conditional Formatting - change cell colors

Posted 11 January 2012 - 02:33 PM

I'm working on an excel sheet and I'm looking to put in an equation similar to

=IF((a1 <= a2)AND (E1 > F1), fill row color red...

I know you can set it to a specific cell using one condition at a time using conditional formatting, but is there a way to write this to fill the cell in the function?

Thanks
Is This A Good Question/Topic? 0
  • +

Replies To: Not using Conditional Formatting - change cell colors

#2 William_Wilson  Icon User is offline

  • lost in compilation
  • member icon

Reputation: 199
  • View blog
  • Posts: 4,807
  • Joined: 23-December 05

Re: Not using Conditional Formatting - change cell colors

Posted 13 January 2012 - 05:15 PM

I'm almost 100% sure this isn't possible.
Other than conditional formatting a Macro is probably the only reasonable way to accomplish this.

Why can't you use conditional formatting?
Was This Post Helpful? 0
  • +
  • -
Page 1 of 1