yogi_Conditionally Format Range B2:C4 -- If Cell <>"-" Color It Orange

Google Spreadsheet   Post  #2305

Yogi Anand, D.Eng, P.E.      ANAND Enterprises LLC -- Rochester Hills MI     Nov-26-2017

question by: Clive J Smith

https://productforums.google.com/forum/?utm_medium=email&utm_source=footer#!topic/docs/_MgNEQ-a1ns;context-place=forum/docs

Conditional Formatting Custom Formula Operators

I use a drop down menu to assign a value to a cell lets call it B8  (eg: -, Ent, CS, AB, SD, RE etc.)

C8 contains other information

I wish to use the fact that B8 is populated by an entry other than "-" to change the background. (To make it simple to see if say, AB has dealt with something)

I have managed to do it with "Ent" as the default operator and have written the formula in Conditional Formatting  =$B$8<>"Ent" for range

B8:C8

This works fine, but when I use =$B$8<>"-" it doesn't work

Also, I wish later to copy and paste this formatting and the formula =B8<>"Ent" also doesn't work in any cell other than the source cell (B8) ie not in C8.