Remember Me?

#1
September 4th 20, 09:53 PM posted to microsoft.public.excel.worksheet.functions
 external usenet poster First recorded activity by ExcelBanter: Sep 2020 Posts: 3
Using IF Function to Recognize Highlighted Cell

I am working in Google Sheets and trying to figure out if I can use the IF Function to recognize a highlighted cell and produce a formula based on the result. For instance, if cell A1 is highlighted yellow (done manually, not based on conditional formatting), then B1=(A1*5) but if A1 is not highlighted yellow then the formula doesn't apply.

TO BE CLEAR, I am not looking to highlight a cell using conditional formatting. I am looking to find a highlighted cell and base a formula off that cell.

Any suggestions on how to use an IF Function (or other function) to recognize the color of a cell? Thanks in advance!

#2
November 18th 20, 02:31 AM posted to microsoft.public.excel.worksheet.functions
 external usenet poster First recorded activity by ExcelBanter: Nov 2020 Posts: 1
Using IF Function to Recognize Highlighted Cell

On Friday, September 4, 2020 at 3:53:29 PM UTC-5, Blythe Richardson Smith wrote:
I am working in Google Sheets and trying to figure out if I can use the IF Function to recognize a highlighted cell and produce a formula based on the result. For instance, if cell A1 is highlighted yellow (done manually, not based on conditional formatting), then B1=(A1*5) but if A1 is not highlighted yellow then the formula doesn't apply.

TO BE CLEAR, I am not looking to highlight a cell using conditional formatting. I am looking to find a highlighted cell and base a formula off that cell.

Any suggestions on how to use an IF Function (or other function) to recognize the color of a cell? Thanks in advance!

 Thread Tools Search this Thread Search this Thread: Advanced Search Display Modes Linear Mode

 Posting Rules Smilies are On [IMG] code is On HTML code is OffTrackbacks are On Pingbacks are On Refbacks are On

 Similar Threads Thread Thread Starter Forum Replies Last Post terryc[_2_] Excel Worksheet Functions 10 February 1st 09 04:57 AM totinnere Excel Programming 2 October 7th 08 09:45 PM RSunday Excel Programming 1 November 16th 07 11:16 AM Martin Williams Excel Worksheet Functions 2 January 23rd 06 12:51 PM Barry Wolfson Excel Programming 1 May 3rd 04 02:37 AM

All times are GMT +1. The time now is 09:05 PM.