Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Old 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
Default 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!

Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Function to recognize 1st of month? terryc[_2_] Excel Worksheet Functions 10 February 1st 09 04:57 AM
Function to Check if Cell is Highlighted for Change in Shared Work totinnere Excel Programming 2 October 7th 08 09:45 PM
Spreadsheet does not recognize my VBA function RSunday Excel Programming 1 November 16th 07 11:16 AM
Can I use a function to detect whether a cell is highlighted? Martin Williams Excel Worksheet Functions 2 January 23rd 06 12:51 PM
VB won't recognize function in Analysis Tool Pak Barry Wolfson Excel Programming 1 May 3rd 04 02:37 AM


All times are GMT +1. The time now is 01:59 PM.

Powered by vBulletin® Copyright ©2000 - 2020, Jelsoft Enterprises Ltd.
Copyright 2004-2020 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"

 

Copyright © 2017